/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50626
 Source Host           : localhost
 Source Database       : tradetrends

 Target Server Type    : MySQL
 Target Server Version : 50626
 File Encoding         : utf-8

 Date: 08/03/2016 21:47:52 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(200) COLLATE utf8_bin NOT NULL,
  `country_name_cn` varchar(200) COLLATE utf8_bin NOT NULL,
  `country_code` varchar(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `country_country_code_65906d37_uniq` (`country_code`),
  KEY `country_55eceb8d` (`country_code`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `country`
-- ----------------------------
BEGIN;
INSERT INTO `country` VALUES ('1', 'UNITED EMIRATES', '阿联酋', 'AE'), ('2', 'AFGHANISTAN', '阿富汗', 'AF'), ('3', 'ALBANIA', '阿尔巴尼亚', 'AL'), ('4', 'ARMENIA', '亚美尼亚', 'AM'), ('5', 'ANGOLA', '安哥拉', 'AO'), ('6', 'ARGENTINA', '阿根廷', 'AR'), ('7', 'AUSTRIA', '奥地利', 'AT'), ('8', 'AUSTRALIA', '澳大利亚', 'AU'), ('9', 'AZERBAIJAN', '阿塞拜疆', 'AZ'), ('10', 'BANGLADESH', '孟加拉', 'BD'), ('11', 'BELGIUM', '比利时', 'BE'), ('12', 'BURKINA FASO', '布基纳法索', 'BF'), ('13', 'BULGARIA', '保加利亚', 'BG'), ('14', 'BAHREIN', '巴林', 'BH'), ('15', 'BURUNDI', '布隆迪', 'BI'), ('16', 'BENIN', '贝宁', 'BJ'), ('17', 'Palestine', '巴勒斯坦', 'BL'), ('18', 'BRUNEI DARUSSALAM', '文莱', 'BN'), ('19', 'BOLIVIA', '玻利维亚', 'BO'), ('20', 'BRAZIL', '巴西', 'BR'), ('21', 'BOTSWANA', '博茨瓦纳', 'BW'), ('22', 'Byelorussia', '白俄罗斯', 'BY'), ('23', 'CANADA', '加拿大', 'CA'), ('24', 'CENTRAL AFRICA', '中非', 'CF'), ('25', 'CONGO', '刚果(布）', 'CG'), ('26', 'Kinshasa', '刚果(金）', 'COD'), ('27', 'SWITZERLAND', '瑞士', 'CH'), ('28', 'CHILE', '智利', 'CL'), ('29', 'CAMEROON', '喀麦隆', 'CM'), ('30', 'CHINA', '中国', 'CN'), ('31', 'COLOMBIA', '哥伦比亚', 'CO'), ('32', 'COSTA RICA', '哥斯达黎加', 'CR'), ('33', 'CZECH REPUBIC', '捷克', 'CZ'), ('34', 'CUBA', '古巴', 'CU'), ('35', 'CYPRUS', '塞浦路斯', 'CY'), ('36', 'GERMANY', '德 国', 'DE'), ('37', 'DENMARK', '丹麦', 'DK'), ('38', 'DOMINICAN REPUBLIC', '多米尼加共和国', 'DO'), ('39', 'ALGERIA', '阿尔及利亚', 'DZ'), ('40', 'ECUADOR', '厄瓜多尔', 'EC'), ('41', 'ESTONIA', '爱沙尼亚', 'EE'), ('42', 'EGYPT', '埃及', 'EG'), ('43', 'SPAIN', '西班牙', 'ES'), ('44', 'ETHIOPIA', '埃塞俄比亚', 'ET'), ('45', 'FINLAND', '芬兰', 'FI'), ('46', 'FIJI', '斐济', 'FJ'), ('47', 'FRANCE', '法国', 'FR'), ('48', 'GABON', '加蓬', 'GA'), ('49', 'UNITED KINGDOM', '英国', 'UK'), ('50', 'GRENADA', '格林纳达', 'GD'), ('51', 'GEORGIA', '格鲁吉亚', 'GE'), ('52', 'GHANA', '加纳', 'GH'), ('53', 'GUINEA', '几内亚', 'GN'), ('54', 'GREECE', '希腊', 'GR'), ('55', 'GUATEMALA', '危地马拉', 'GT'), ('56', 'HONG KONG', '香港特别行政区', 'HK'), ('57', 'HONDURAS', '洪都拉斯', 'HN'), ('58', 'HUNGARY', '匈牙利', 'HU'), ('59', 'INDONESIA', '印度尼西亚', 'ID'), ('60', 'IRELAND', '爱尔兰', 'IE'), ('61', 'ISRAEL', '以色列', 'IL'), ('62', 'INDIA', '印度', 'IN'), ('63', 'IRAQ', '伊拉克', 'IQ'), ('64', 'IRAN', '伊朗', 'IR'), ('65', 'ICELAND', '冰岛', 'IS'), ('66', 'ITALY', '意大利', 'IT'), ('67', 'JAMAICA', '牙买加', 'JM'), ('68', 'JORDAN', '约旦', 'JO'), ('69', 'JAPAN', '日本', 'JP'), ('70', 'KYRGYZSTAN', '吉尔吉斯坦', 'KG'), ('71', 'KAMPUCHEA', '柬埔寨', 'KH'), ('72', 'KOREA,DEM.PEOPLE’S', '北朝鲜', 'KP'), ('73', 'REPUBLIC OF KOREA', '韩国', 'KR'), ('74', 'COTE O’IVOIRE', '科特迪瓦共和国', 'KT'), ('75', 'KUWATI', '科威特', 'KW'), ('76', 'KAZAKHSTAN', '哈萨克', 'KZ'), ('77', 'LAOS', '老挝', 'LA'), ('78', 'LEBANON', '黎巴嫩', 'LB'), ('79', 'SAINT LUEIA', '圣卢西亚', 'LC'), ('80', 'LIECHTENSTEIN', '列支敦士登', 'LI'), ('81', 'SRI LANKA', '斯里兰卡', 'LK'), ('82', 'LIBERIA', '利比里亚', 'LR'), ('83', 'LITHUANIA', '立陶宛', 'LT'), ('84', 'LUXEMBOURG', '卢森堡', 'LU'), ('85', 'LATVIA', '拉脱维亚', 'LV'), ('86', 'LIBYAN', '利比亚', 'LY'), ('87', 'MOROCCO', '摩洛哥', 'MA'), ('88', 'MONACO', '摩纳哥', 'MC'), ('89', 'MOLDOVA,REPUBLIC OF', '摩尔多瓦', 'MD'), ('90', 'MADAGASCAR', '马达加斯加', 'MG'), ('91', 'MALI', '马里', 'ML'), ('92', 'BURMA', '缅甸', 'MM'), ('93', 'MONGOLIA', '蒙古', 'MN'), ('94', 'MACAU', '澳门地区', 'MO'), ('95', 'MALTA', '马耳他', 'MT'), ('96', 'MAURITIUS', '毛里求斯', 'MU'), ('97', 'MALAWI', '马拉维', 'MW'), ('98', 'MEXICO', '墨西哥', 'MX'), ('99', 'MALAYSIA', '马来西亚', 'MY'), ('100', 'MOZAMBIQUE', '莫桑比克', 'MZ'), ('101', 'NAMIBIA', '纳米比亚', 'NA'), ('102', 'NIGER', '尼日尔', 'NE'), ('103', 'NIGERIA', '尼日利亚', 'NG'), ('104', 'NICARAGUA', '尼加拉瓜', 'NI'), ('105', 'NETHERLANDS', '荷兰', 'NL'), ('106', 'NORWAY', '挪威', 'NO'), ('107', 'NEPAL', '尼泊尔', 'NP'), ('108', 'NEW ZEALAND', '新西兰', 'NZ'), ('109', 'OMAN', '阿曼', 'OM'), ('110', 'PANAMA', '巴拿马', 'PA'), ('111', 'PERU', '秘鲁', 'PE'), ('112', 'PAPUA NEW GUINEA', '巴布亚新几内亚', 'PG'), ('113', 'PHILIPPINES', '菲律宾', 'PH'), ('114', 'PAKISTAN', '巴基斯坦', 'PK'), ('115', 'POLAND', '波兰', 'PL'), ('116', 'PORTUGAL', '葡萄牙', 'PT'), ('117', 'PARAGUAY', '巴拉圭', 'PY'), ('118', 'QATAR', '卡塔尔', 'QA'), ('119', 'ROMANIA', '罗马尼亚', 'RO'), ('120', 'RUSSIAN FEDERATION', '俄罗斯', 'RU'), ('121', 'SAUDI ARABIA', '沙特阿拉伯', 'SA'), ('122', 'SEYCHELLES', '塞舌尔', 'SC'), ('123', 'SUDAN', '苏丹', 'SD'), ('124', 'SWEDEN', '瑞典', 'SE'), ('125', 'SINGAPORE', '新加坡', 'SG'), ('126', 'SLOVENIA', '斯洛文尼亚', 'SI'), ('127', 'SLOVAKIA', '斯洛伐克', 'SK'), ('128', 'SAN MARINO', '圣马力诺', 'SM'), ('129', 'SENEGAL', '塞内加尔', 'SN'), ('130', 'SOMALIA', '索马里', 'SO'), ('131', 'SYRIA', '叙利亚', 'SY'), ('132', 'SWAZILAND', '斯威士兰', 'SZ'), ('133', 'CHAD', '乍得', 'TD'), ('134', 'TOGO', '多哥', 'TG'), ('135', 'THAILAND', '泰国', 'TH'), ('136', 'TAJIKISTAN', '塔吉克斯坦', 'TJ'), ('137', 'TURKMENISTAN', '土库曼', 'TM'), ('138', 'TUNISIA', '突尼斯', 'TN'), ('139', 'TURKEY', '土耳其', 'TR'), ('140', 'TAIWAN', '台湾省', 'TW'), ('141', 'TANZANIA', '坦桑尼亚', 'TZ'), ('142', 'UKRAINE', '乌克兰', 'UA'), ('143', 'UGANDA', '乌干达', 'UG'), ('144', 'UNITED STATES', '美国', 'US'), ('145', 'URUGUAY', '乌拉圭', 'UY'), ('146', 'UZBEKISTAN', '乌兹别克', 'UZ'), ('147', 'SAINT VINCENT', '圣文森特岛', 'VC'), ('148', 'VENEZUELA', '委内瑞拉', 'VE'), ('149', 'VIET NAM', '越南', 'VN'), ('150', 'YEMEN', '也门', 'YE'), ('151', 'YUGOSLAVIA', '南斯拉夫联盟', 'YU'), ('152', 'SOUTH AFRICA', '南非', 'ZA'), ('153', 'ZAMBIA', '赞比亚', 'ZM'), ('154', 'ZAIRE', '扎伊尔', 'ZR'), ('155', 'ZIMBABWE', '津巴布韦', 'ZW');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
